Telegram Group & Telegram Channel
πŸ–₯ SQLGlot β€” парсСр, ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ‚ΠΎΡ€ ΠΈ Π΄Π²ΠΈΠΆΠΎΠΊ SQL Π½Π° Python

β€” pip3 install "sqlglot[rs]"

SQLGlot ΠΌΠΎΠΆΠ΅Ρ‚ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒΡΡ для форматирования SQL ΠΈΠ»ΠΈ ΠΏΠ΅Ρ€Π΅Π²ΠΎΠ΄Π° ΠΌΠ΅ΠΆΠ΄Ρƒ 21 Ρ€Π°Π·Π»ΠΈΡ‡Π½Ρ‹ΠΌΠΈ Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚Π°ΠΌΠΈ, Π² Ρ‚ΠΎΠΌ числС DuckDB, Presto / Trino, Spark / Databricks, Snowflake ΠΈ BigQuery. Он ΠΏΡ€Π΅Π΄Π½Π°Π·Π½Π°Ρ‡Π΅Π½ для чтСния ΡˆΠΈΡ€ΠΎΠΊΠΎΠ³ΠΎ спСктра Π²Ρ…ΠΎΠ΄Π½Ρ‹Ρ… Π΄Π°Π½Π½Ρ‹Ρ… SQL ΠΈ Π²Ρ‹Π²ΠΎΠ΄Π° синтаксичСски ΠΈ сСмантичСски ΠΊΠΎΡ€Ρ€Π΅ΠΊΡ‚Π½ΠΎΠ³ΠΎ SQL Π½Π° Ρ†Π΅Π»Π΅Π²Ρ‹Ρ… Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚Π°Ρ….

SQLGlot β€” это ΠΎΡ‡Π΅Π½ΡŒ ΠΏΠΎΠ»Π½Ρ‹ΠΉ ΠΎΠ±Ρ‰ΠΈΠΉ парсСр SQL с Π½Π°Π΄Π΅ΠΆΠ½Ρ‹ΠΌ Π½Π°Π±ΠΎΡ€ΠΎΠΌ тСстов. Он Ρ‚Π°ΠΊΠΆΠ΅ достаточно ΠΏΡ€ΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡ‚Π΅Π»Π΅Π½ (Π·Π° счёт Ρ‚ΠΎΠΊΠ΅Π½ΠΈΠ·Π°Ρ‚ΠΎΡ€Π° Π½Π° Rust) ΠΈ ΠΏΡ€ΠΈ этом написан ΠΈΡΠΊΠ»ΡŽΡ‡ΠΈΡ‚Π΅Π»ΡŒΠ½ΠΎ Π½Π° Python.

Π’Ρ‹ ΠΌΠΎΠΆΠ΅Ρ‚Π΅ Π»Π΅Π³ΠΊΠΎ Π½Π°ΡΡ‚Ρ€Π°ΠΈΠ²Π°Ρ‚ΡŒ парсСр, Π°Π½Π°Π»ΠΈΠ·ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ запросы, ΠΎΠ±Ρ…ΠΎΠ΄ΠΈΡ‚ΡŒ Π΄Π΅Ρ€Π΅Π²ΡŒΡ Π²Ρ‹Ρ€Π°ΠΆΠ΅Π½ΠΈΠΉ ΠΈ ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎ ΡΠΎΠ·Π΄Π°Π²Π°Ρ‚ΡŒ SQL.

БинтаксичСскиС ошибки ΠΏΠΎΠ΄ΡΠ²Π΅Ρ‡ΠΈΠ²Π°ΡŽΡ‚ΡΡ, Π½Π΅ΡΠΎΠ²ΠΌΠ΅ΡΡ‚ΠΈΠΌΠΎΡΡ‚ΡŒ Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚ΠΎΠ² отобраТаСтся, ΠΎΠ΄Π½Π°ΠΊΠΎ SQLGlot Π½Π΅ стрСмится Π±Ρ‹Ρ‚ΡŒ Π²Π°Π»ΠΈΠ΄Π°Ρ‚ΠΎΡ€ΠΎΠΌ SQL, поэтому ΠΎΠ½ ΠΌΠΎΠΆΠ΅Ρ‚ Π½Π΅ ΠΎΠ±Π½Π°Ρ€ΡƒΠΆΠΈΡ‚ΡŒ Π½Π΅ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ синтаксичСскиС ошибки.

πŸ–₯ GitHub

@pythonl
Please open Telegram to view this post
VIEW IN TELEGRAM



tg-me.com/pythonl/3786
Create:
Last Update:

πŸ–₯ SQLGlot β€” парсСр, ΠΎΠΏΡ‚ΠΈΠΌΠΈΠ·Π°Ρ‚ΠΎΡ€ ΠΈ Π΄Π²ΠΈΠΆΠΎΠΊ SQL Π½Π° Python

β€” pip3 install "sqlglot[rs]"

SQLGlot ΠΌΠΎΠΆΠ΅Ρ‚ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒΡΡ для форматирования SQL ΠΈΠ»ΠΈ ΠΏΠ΅Ρ€Π΅Π²ΠΎΠ΄Π° ΠΌΠ΅ΠΆΠ΄Ρƒ 21 Ρ€Π°Π·Π»ΠΈΡ‡Π½Ρ‹ΠΌΠΈ Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚Π°ΠΌΠΈ, Π² Ρ‚ΠΎΠΌ числС DuckDB, Presto / Trino, Spark / Databricks, Snowflake ΠΈ BigQuery. Он ΠΏΡ€Π΅Π΄Π½Π°Π·Π½Π°Ρ‡Π΅Π½ для чтСния ΡˆΠΈΡ€ΠΎΠΊΠΎΠ³ΠΎ спСктра Π²Ρ…ΠΎΠ΄Π½Ρ‹Ρ… Π΄Π°Π½Π½Ρ‹Ρ… SQL ΠΈ Π²Ρ‹Π²ΠΎΠ΄Π° синтаксичСски ΠΈ сСмантичСски ΠΊΠΎΡ€Ρ€Π΅ΠΊΡ‚Π½ΠΎΠ³ΠΎ SQL Π½Π° Ρ†Π΅Π»Π΅Π²Ρ‹Ρ… Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚Π°Ρ….

SQLGlot β€” это ΠΎΡ‡Π΅Π½ΡŒ ΠΏΠΎΠ»Π½Ρ‹ΠΉ ΠΎΠ±Ρ‰ΠΈΠΉ парсСр SQL с Π½Π°Π΄Π΅ΠΆΠ½Ρ‹ΠΌ Π½Π°Π±ΠΎΡ€ΠΎΠΌ тСстов. Он Ρ‚Π°ΠΊΠΆΠ΅ достаточно ΠΏΡ€ΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡ‚Π΅Π»Π΅Π½ (Π·Π° счёт Ρ‚ΠΎΠΊΠ΅Π½ΠΈΠ·Π°Ρ‚ΠΎΡ€Π° Π½Π° Rust) ΠΈ ΠΏΡ€ΠΈ этом написан ΠΈΡΠΊΠ»ΡŽΡ‡ΠΈΡ‚Π΅Π»ΡŒΠ½ΠΎ Π½Π° Python.

Π’Ρ‹ ΠΌΠΎΠΆΠ΅Ρ‚Π΅ Π»Π΅Π³ΠΊΠΎ Π½Π°ΡΡ‚Ρ€Π°ΠΈΠ²Π°Ρ‚ΡŒ парсСр, Π°Π½Π°Π»ΠΈΠ·ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ запросы, ΠΎΠ±Ρ…ΠΎΠ΄ΠΈΡ‚ΡŒ Π΄Π΅Ρ€Π΅Π²ΡŒΡ Π²Ρ‹Ρ€Π°ΠΆΠ΅Π½ΠΈΠΉ ΠΈ ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎ ΡΠΎΠ·Π΄Π°Π²Π°Ρ‚ΡŒ SQL.

БинтаксичСскиС ошибки ΠΏΠΎΠ΄ΡΠ²Π΅Ρ‡ΠΈΠ²Π°ΡŽΡ‚ΡΡ, Π½Π΅ΡΠΎΠ²ΠΌΠ΅ΡΡ‚ΠΈΠΌΠΎΡΡ‚ΡŒ Π΄ΠΈΠ°Π»Π΅ΠΊΡ‚ΠΎΠ² отобраТаСтся, ΠΎΠ΄Π½Π°ΠΊΠΎ SQLGlot Π½Π΅ стрСмится Π±Ρ‹Ρ‚ΡŒ Π²Π°Π»ΠΈΠ΄Π°Ρ‚ΠΎΡ€ΠΎΠΌ SQL, поэтому ΠΎΠ½ ΠΌΠΎΠΆΠ΅Ρ‚ Π½Π΅ ΠΎΠ±Π½Π°Ρ€ΡƒΠΆΠΈΡ‚ΡŒ Π½Π΅ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ синтаксичСскиС ошибки.

πŸ–₯ GitHub

@pythonl

BY Python/ django





Share with your friend now:
tg-me.com/pythonl/3786

View MORE
Open in Telegram


Python django Telegram | DID YOU KNOW?

Date: |

Telegram has exploded as a hub for cybercriminals looking to buy, sell and share stolen data and hacking tools, new research shows, as the messaging app emerges as an alternative to the dark web.An investigation by cyber intelligence group Cyberint, together with the Financial Times, found a ballooning network of hackers sharing data leaks on the popular messaging platform, sometimes in channels with tens of thousands of subscribers, lured by its ease of use and light-touch moderation.

Export WhatsApp stickers to Telegram on Android

From the Files app, scroll down to Internal storage, and tap on WhatsApp. Once you’re there, go to Media and then WhatsApp Stickers. Don’t be surprised if you find a large number of files in that folderβ€”it holds your personal collection of stickers and every one you’ve ever received. Even the bad ones.Tap the three dots in the top right corner of your screen to Select all. If you want to trim the fat and grab only the best of the best, this is the perfect time to do so: choose the ones you want to export by long-pressing one file to activate selection mode, and then tapping on the rest. Once you’re done, hit the Share button (that β€œless than”-like symbol at the top of your screen). If you have a big collectionβ€”more than 500 stickers, for exampleβ€”it’s possible that nothing will happen when you tap the Share button. Be patientβ€”your phone’s just struggling with a heavy load.On the menu that pops from the bottom of the screen, choose Telegram, and then select the chat named Saved messages. This is a chat only you can see, and it will serve as your sticker bank. Unlike WhatsApp, Telegram doesn’t store your favorite stickers in a quick-access reservoir right beside the typing field, but you’ll be able to snatch them out of your Saved messages chat and forward them to any of your Telegram contacts. This also means you won’t have a quick way to save incoming stickers like you did on WhatsApp, so you’ll have to forward them from one chat to the other.

Python django from br


Telegram Python/ django
FROM USA